<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>Add a cross tab to the report</title>
    <link rel="StyleSheet" href="css/crosstab.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="ct-TutT4SetUpDataForTheCrossTab.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="ct-TutT6AddGrandTotals.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h3 class="N_TutorialTask">Task 5:&nbsp;&nbsp;<a name="222021">Add a cross tab to the report</a></h3>
      <p class="b_Body"><a name="222033">In this procedure, you add a cross tab to the report, then you insert data from the cube into the cross tab.</a></p>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="367512">Choose the palette, then drag a cross-tab element from the palette to the report. A cross tab appears in the report.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="367509">Choose Data Explorer. Under the first group in the Sales cube, drag STATE and drop it in the cross-tab area that displays the following text:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="cfi_CodeFirstIndent"><a name="441973">Drop data field(s) to define rows here</a></div>
      <div class="N_i_Indent1"><a href="#613985" title="Add a cross tab to the report" name="441986">Figure&nbsp;16-8</a> shows inserting STATE in this location.</div>
      <p class="i2_Image2"><a name="613983"><img class="Default" src="images/crosstab.16.7.1.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 16-8 Inserting STATE data in the cross tab" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;16-8&nbsp;&nbsp;</b><a name="613985">Inserting STATE data in the cross tab</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="341064">From the Sales cube, under Group1, drag PRODUCTLINE and drop it in the cross-tab area that displays the following text:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="cfi_CodeFirstIndent"><a name="442003">Drop data field(s) to define columns here</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="222077">From the Sales cube, under Summary Field, drag EXTENDED_PRICE and drop it in the cross-tab area that displays the following text:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="cfi_CodeFirstIndent"><a name="442020">Drop data field(s) to be summarized here</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">5&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="307336">Using the property editor, select Hide Measure Header for the crosstab.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_i_Indent1"><a name="581170">The cross tab should look like the one shown in </a><a href="#307342" title="Add a cross tab to the report">Figure&nbsp;16-9</a>.</div>
      <p class="i2_Image2"><a name="307340"><img class="Default" src="images/xtab_layout2.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 16-9 Cross tab design" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;16-9&nbsp;&nbsp;</b><a name="307342">Cross tab design</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">6&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="375867">Choose Preview. </a><a href="#307330" title="Add a cross tab to the report">Figure&nbsp;16-10</a> shows a portion of the data that the cross tab displays.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="307328"><img class="Default" src="images/xtab_output1.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 16-10 Preview of the cross tab data" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;16-10&nbsp;&nbsp;</b><a name="307330">Preview of the cross tab data</a></div>
      <div class="N_i_Indent1"><a name="521415">The row headings display the states, the column headings display product lines, and the cells display the sales totals. The first cell displays 458563.64, which is the sales total of classic cars sold in California.</a></div>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>